From ed81e57ab84f580e457ed9c499799f850e5f88d4 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 20 Jul 2026 17:21:08 +0000 Subject: [PATCH] Move BIOGRAPHY_LOG into the housekeeping schema --- db/schemas/housekeeping/indexes/Makefile | 1 + .../{sokwedb => housekeeping}/indexes/create/biography_log.m4 | 0 .../{sokwedb => housekeeping}/indexes/drop/biography_log.m4 | 0 db/schemas/housekeeping/tables/Makefile | 1 + .../{sokwedb => housekeeping}/tables/create/biography_log.m4 | 0 db/schemas/sokwedb/indexes/Makefile | 2 +- db/schemas/sokwedb/tables/Makefile | 1 - doc/src/housekeeping.m4 | 1 + doc/src/{tables => housekeeping}/biography_log.m4 | 0 doc/src/tables.m4 | 1 - 10 files changed, 4 insertions(+), 3 deletions(-) rename db/schemas/{sokwedb => housekeeping}/indexes/create/biography_log.m4 (100%) rename db/schemas/{sokwedb => housekeeping}/indexes/drop/biography_log.m4 (100%) rename db/schemas/{sokwedb => housekeeping}/tables/create/biography_log.m4 (100%) rename doc/src/{tables => housekeeping}/biography_log.m4 (100%) diff --git a/db/schemas/housekeeping/indexes/Makefile b/db/schemas/housekeeping/indexes/Makefile index 12642e3..c865154 100644 --- a/db/schemas/housekeeping/indexes/Makefile +++ b/db/schemas/housekeeping/indexes/Makefile @@ -20,6 +20,7 @@ # This determines the order in which the indexes are put into the database. # This is not really important but is needed for other types of db objects. ORDER := aggression_event_log \ + biography_log \ chimps_on_tikis ## diff --git a/db/schemas/sokwedb/indexes/create/biography_log.m4 b/db/schemas/housekeeping/indexes/create/biography_log.m4 similarity index 100% rename from db/schemas/sokwedb/indexes/create/biography_log.m4 rename to db/schemas/housekeeping/indexes/create/biography_log.m4 diff --git a/db/schemas/sokwedb/indexes/drop/biography_log.m4 b/db/schemas/housekeeping/indexes/drop/biography_log.m4 similarity index 100% rename from db/schemas/sokwedb/indexes/drop/biography_log.m4 rename to db/schemas/housekeeping/indexes/drop/biography_log.m4 diff --git a/db/schemas/housekeeping/tables/Makefile b/db/schemas/housekeeping/tables/Makefile index 5b6366c..6a7702d 100644 --- a/db/schemas/housekeeping/tables/Makefile +++ b/db/schemas/housekeeping/tables/Makefile @@ -21,6 +21,7 @@ # This is important because the tables containing foreign keys must be put # into the database after the tables they reference. ORDER := aggression_event_log \ + biography_log \ chimps_on_tikis ## diff --git a/db/schemas/sokwedb/tables/create/biography_log.m4 b/db/schemas/housekeeping/tables/create/biography_log.m4 similarity index 100% rename from db/schemas/sokwedb/tables/create/biography_log.m4 rename to db/schemas/housekeeping/tables/create/biography_log.m4 diff --git a/db/schemas/sokwedb/indexes/Makefile b/db/schemas/sokwedb/indexes/Makefile index 5973019..7e3e977 100644 --- a/db/schemas/sokwedb/indexes/Makefile +++ b/db/schemas/sokwedb/indexes/Makefile @@ -19,7 +19,7 @@ # This determines the order in which the indexes are put into the database. # This is not really important but is needed for other types of db objects. -ORDER := biography_data biography_log comm_membs comm_memb_log \ +ORDER := biography_data comm_membs comm_memb_log \ watches follow_observers follow_studies events roles arrivals \ swelling_sources swelling_states sightings \ aggressions food_events groomings attendance \ diff --git a/db/schemas/sokwedb/tables/Makefile b/db/schemas/sokwedb/tables/Makefile index 76ade06..c46cbd0 100644 --- a/db/schemas/sokwedb/tables/Makefile +++ b/db/schemas/sokwedb/tables/Makefile @@ -21,7 +21,6 @@ # This is important because the tables containing foreign keys must be put # into the database after the tables they reference. ORDER := biography_data \ - biography_log \ swelling_sources \ swelling_states \ comm_membs \ diff --git a/doc/src/housekeeping.m4 b/doc/src/housekeeping.m4 index d704b6a..a6e3443 100644 --- a/doc/src/housekeeping.m4 +++ b/doc/src/housekeeping.m4 @@ -34,4 +34,5 @@ The tables in this section are all in the ``housekeeping`` schema. :maxdepth: 3 housekeeping/aggression_event_log.rst + housekeeping/biography_log.rst housekeeping/chimps_on_tikis.rst diff --git a/doc/src/tables/biography_log.m4 b/doc/src/housekeeping/biography_log.m4 similarity index 100% rename from doc/src/tables/biography_log.m4 rename to doc/src/housekeeping/biography_log.m4 diff --git a/doc/src/tables.m4 b/doc/src/tables.m4 index 241b92b..5e8d1e7 100644 --- a/doc/src/tables.m4 +++ b/doc/src/tables.m4 @@ -36,7 +36,6 @@ and are therefore the result of at least a rudimentary analytical process. tables/arrivals.rst tables/arrivals_a.rst tables/biography_data.rst - tables/biography_log.rst tables/brecord_notes.rst tables/colobus.rst tables/comm_membs.rst -- 2.34.1